with conditional formatting
select the rows
FormatConditional Formatting
change condition to FormulaIs
add a formula of =$E1="I"
click Format
select Pattern tab
choose a colour
OK out
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Daniell" wrote in message
...
I have a large spreadsheet that I need to make an eye catcher for people.
I
would like to color column A, B, C, if column E is equal to "I" is this
possible?
|