Conditional Formatting

[Jzelenka]

Hello,

I have a worksheet of many different kinds of information. I would like to have certain lines automatically edit itsef according to certain criteria.

I go to "conditional formatting" and for condition 1, I have:
=$f5="N", then the entire line bolds red
and italicizes
For condition 2, I have:
=$g5="YES", then the entire line bolds
black
For condition 3, I want to have... but it is not working:
if G5 = yes, AND if H5 = No, I want the entire line highlighted yellow, but still bolded from condition 2.

Is there any way to do this kind of formatting command easily????

Thanks, and any help would be great!

 

[lenze]

Reverse conditions 2 and 3

Condition 1 =$F$5="N" highlight Red

Condition2 =AND($G$5="YES",$H$5="No") highlight Yellow etc

Condition 3 =$G$5="YES" Highlight Black etc
This message was edited by lenze on 2002-10-03 15:08