Conditional Format formula (Excel 2003 SP2)

Topic

New Reply

Hi all!
Attached is a sample workbook. Can someone please tell me how to create a formula for use by Conditional Formatting that would give the same results as the sample? I do not want to use VBA to accomplish it.
If a cell is Blank or contains one of two preset numbers, the background is Pale Blue. Anything else would cause background to be Red.

Thanks a Heap!
Chuck

Reply | Quote

Replies

Here are 2 ways:

1) select F10:F18 and color them all blue
format – conditional formatting –
Formula is:
=AND(NOT(ISBLANK(F10)),F10$C$3,F10$C$4)
[Format} Patterns tab
Choose Red
[ok][ok]

2) select F10:F18 and color them all Red
format – conditional formatting –
Formula is:
=OR(ISBLANK(F10),F10=$C$3,F10=$C$4)
[Format} Patterns tab
Choose Blue
[ok][ok]

Steve

Reply | Quote

Steve,

Thanks! I knew I had seen something like this before, but I am not very good at finding what I need when searching (I did try).

Thanks again,
Chuck

Reply | Quote