Conditional formatting

[hugrl]

hi all
if cell C3 is blank cell B2 turns red

cell C3 is alreay conditional formated to turn green if greater than 0

these are times in cells C3 D3 E3 F3

also like cell C3 to turn amber if H is entered in cell C3 but green if TIME entered in cell C3

many thanks

[NBVC]

try:

Condition 1: Formula Is: =B3="" (red)

Condition 2: Cell Value Is: Equal to : ="H" (amber)

Condition 3: Cell Value Is: Greater Than: =0 (green)

[hugrl]

sorry not working

[NBVC]

How is it not working?

See attached and test...

[hugrl]

sorry cell B3 to turn amber not cell C3

[NBVC]

In B3, invoke CF separately and use:

Formula Is: =$C3="H"