Conditional formatting

  • Thread starter Thread starter Pascale
  • Start date Start date
P

Pascale

I have read several tips however, I cannot get my formatting to work.

column X has a formula in it determining whether the issue is open o
the number of days taken to close. I would like to the text colour i
the whole row to be red if open, and green if a number is entered.

If i perform the conditional formatting on the cell itself that is x
for instance i can get the colour to change using
CF#1 : cell value is - equal to - "open" format red
CF#2 : cell value is - greater than - 1 format green

If i select the row and then
CF#1 : cell value is - equal to - $X$3="open" format red

i can't even get this to work......let alone the next requirement.
just can't figure it out....
please help

Thank you in advanc
 
Try:

Select the row:
CF1: Formula is =$X3="open"
Format1: Red
CF2: Formula is =AND($X3<>"",$X3>=0)
Format2: Green
 
Back
Top