Color code Row
 

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?

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?