Conditional formatting
From: David (anonymous_at_discussions.microsoft.com)
Date: 08/13/04
- Next message: Ron Rosenfeld: "Re: Countif problem?"
- Previous message: Hannah Madsen: "Re: autorank"
- Next in thread: Remus: "RE: Conditional formatting"
- Reply: Remus: "RE: Conditional formatting"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 13 Aug 2004 04:04:13 -0700
I have three columns E for a Target Date, F for a closed
Date and H for Today's date with the following statement
in column G which is for Status
=IF(F2=0,IF(E2>$H$2,"In Progress","Late"),"Completed")
This works but I want to return colors instead of text in
column G. I set up conditional formatting using three
cell colors RED for Late, YELLOW for In Progress and
GREEN for Completed and this returns colors and text. All
I can do is reduce the font size to 1 but I can't make it
transparent. Ideally what I want is to replace the words
with colors in the formula but I can't find the code -
can you help?
David
- Next message: Ron Rosenfeld: "Re: Countif problem?"
- Previous message: Hannah Madsen: "Re: autorank"
- Next in thread: Remus: "RE: Conditional formatting"
- Reply: Remus: "RE: Conditional formatting"
- Messages sorted by: [ date ] [ thread ]