Possible Conditional Formatting

[Biff]

Hi Sally,

You would have to do that in 2 seperate operations(or use
a macro). You can't alter the size of a cell through
conditional formatting. You can define the size of the
font in a cell with conditional formatting. You would need
to do a regular format and merge and center the text in
those cells. Then put this formula in that mergered cell:

=IF(C11>8.5,"REJECTED","")

Then you simply set the font color as yellow. With the
above formula, if the condition is not true then the cell
is left blank so no conditional formatting is needed.

Biff

 

[Biff]

Ooops! I see you wanted to set the FILL color not the
font. In that case you will need conditional formatting
but a formula is not neccessary. Goto Format>Conditional
Formatting
Cell value is
Equal to
Rejected

Biff