Conditional formating help.

[JustMe602]

I need help with setting up conditional formating in a column.


At the bottom of say Column B when a string of text is input I woul
like to have it change the format of all the cells that equal the inpu
to change to say bold and red and if they don't equal then to have the
change to say gray. That part I figured out. The part need help with i
when the cell at the bottom is blank I don't want to one of the previou
conditions to apply. Right now when it is blank the 2nd condition i
working. Thus all my cells above are gray because none of the cells ar
blank. I would rather them be normal color... So I need help on th
syntax of the 3rd condition.

Let me know if you I need to further explain this situation.

Thanks.
JustMe

 

[msuryexcel]

Hi
I think having the third condition be: if blank mark it white - should
work along with the first two conditions you stated
msuryexcel

 

[JustMe602]

Okay but I need the syntax for the third condition

 

[JE McGimpsey]

One way:

Enter this CF (assuming B100 is the cell "at the bottom", your column B
cells are selected, and B1 is the active cell):

CF1: Formula is =AND(B$100<>"",B1=B$100)
Format1: Font/<bold><red>

CF2: Formula is =B$100<>""
Format2: Font/<gray>

 

[swatsp0p]

Try reordering your conditions. CF works in logical order, IF the first
condition is true, it applies that formatting and stops. IF the first
is not true, it goes on to number 2.

I would start with cond 1 as =$B$100="" and set my condition as no
fill, standard font, etc.

Cond. 2 would test for your specific cell input as =$B$100="Yourtext"
and set Red/Bold

Cond. 3 would be: =$B$100<>"Yourtext" and set to gray, etc.

Good Luck