Conditional Formatting and Indirect Function

**gmc2k2** · 02-03-2011, 08:05 PM

Hi im trying to get a conditional format to work where i have 2 rules,
First one :=INDIRECT("G"&ROW())>0 and it highlights the row green
Second One: =AND(INDIRECT("C"&ROW())>0,("G"&ROW())="""")
but the second one isnt working, what im trying to do with the second rule is if a cell in row C is not blank and the Cell in row G is blank then to highlight the row red...but this isnt working, have i mistyped the formula or have the rules in the wrong order?
please help
thanks

**ConneXionLost** · 02-03-2011, 08:14 PM

How about:

Please Login or Register  to view this content.

Cheers,

**gmc2k2** · 02-03-2011, 08:20 PM

i've added that as the conditional format but nothing seems to happen it still stays no colour, the only time it changes is when column g is not blank and then the row goes green...i cant seem to make the row go red if column c is not blank and row g is...???
in my rules i have the green one first and red rule second...but either order isnt working

**martindwilson** · 02-03-2011, 09:13 PM

in any cell in row one
rule 1
=$G1>0
rule 2
=AND($C1<>"",$G1="")
applied as far along a row as you need and extended down should do it
of course if you start in say c5 adjust accordingly
=AND($C5<>"",$G5="")