Conditional Formatting 2 events

[millerlite2ky]

Condition 1: if the cell (c4) is not blank, then I want cell (h4) to format a gray shade fill. Condition 2: Then if cell (H4) equals cell (c4), then I want the cell to unshade and be a red font color.
Condition 3: But if the cell (h4) doesn't equal (C4), then I want the cell to stay gray filled, but have the red font.

I've tried several times, but it only will read the first condition. I'm using Excel 2003 at work and am setting up a logsheet for items being checked out for use by employees. As they check an item out (C4), then cell (H4) will gray fill until item is checked back after use. At that time, I want Excel to do condition 2 if the same item is checked back in or do condition 3 if the item doesn't match.

Thanks for any help,

Scott

 

[JB_Scotland]

Cell H4 Format: Font Colour Automatic and No Fill

Cell H4 Conditional Format 1: Formula Is =AND($C$4<>"",$C$4<>$H$4) Format: Red Font on Gray Fill

Cell H4 Conditional Format 2: Formula Is =IF($C$4=$H$4,1,0) Format: Red Font on No Fill

 

[Marcelo Branco]

Hi,

What are your priorities in the following situations
C4 = H4
C4 not blank

Do you want gray-fill or red-font and no-fill?

and
C4<>H4
C4 not blank

Do you want gray-fill or gray-fill and red-font?

M.