Thread
:
Conditional formatting in Excel 2003
View Single Post
#
2
Posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
Posts: 8,651
Conditional formatting in Excel 2003
Conditional Formatting/ *Formula Is*/ =$A1="YES"
Set your Green option
Add
Similarly for your Red option
--
David Biddulph
"Bruce McGinnis" <Bruce
wrote in message
...
How can I format one cell based on the contents of another cell. I would
like
to have the color of a row of cells change automatically based on the
contents of one of the cells in the subject row. Example: if A1 reads
"YES",
then I want cells A1 through G1 to change color from no color to green. if
A1
reads "NO", then I want cells A1 through G1 to change color to red and if
A!
is blank, then I want the cells to stay with no color.
Reply With Quote
David Biddulph[_2_]
View Public Profile
Find all posts by David Biddulph[_2_]