Conditional Formatting

[Guest]

How can I use conditional formatting to highlight a row when the cell in
column AD on that row is blank, and unhighlight the row when it has an X in
it.

 

[RagDyer]

What's supposed to happen to the row if the AD cell is *not* blank, and does
*not* contain an "X"?

Say it contains a number?
--


Regards,

RD

 

[Guest]

ok, I figured out how to do the whole cell, by using =($AD11="").
My next question would be, how do I keep it from highlighting rows that are
empty?
Can this be done?

 

[Guest]

column AD will only contain an X because it has a formula that when column Y
has a # in it, it will put an X in AD. When AD has an X in it, I want the
cell to look like the original format of the sheet. The X marks that the
task is complete. I want to be able to open this page and see what tasks are
not complete by them being highlighted. So when a completed date is entered,
cell AD will contain an X, and the row will be un highlighted. I just can't
figure out how to keep the rows that do not contain tasks from being
highlighted until the have a task in them.
Thanks

 

[Guest]

ok, been working on this more, figured out how to keep it from highliting
until there is a task, BUT, I can't get it to unhighlight when there is a
date in column Y. I have taken out the completed column. NO X involved
anymore...hehe. My first condition is:
=B11
this highlights the row when a task is keyed in.
Now I need to unhighlight the row when the task completion date is keyed in.
Any thoughts???

 

[RagDyeR]

Is this what you're looking for?

Say you key in the start date in B2
This turns row2 yellow.

When you key in end date in Y2, yellow format disappears.


First, select *all* of row2, then:
<Format> <ConditionalFormatting>

Click "Formula Is", and enter this:

=AND($B$2>0,$Y$2="")

Select your formatting, then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message ok, been working on this more, figured out how to keep it from highliting
until there is a task, BUT, I can't get it to unhighlight when there is a
date in column Y. I have taken out the completed column. NO X involved
anymore...hehe. My first condition is:
=B11
this highlights the row when a task is keyed in.
Now I need to unhighlight the row when the task completion date is keyed in.
Any thoughts???