Color code Row

D

Daniell

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?
 
B

Bob Phillips

with conditional formatting

select the rows
Format>Conditional 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)
 
Top