View Single Post
Old March 10th, 2010, 05:40 PM posted to microsoft.public.excel.newusers
external usenet poster
Posts: 26
Default fill a color to a row

=$H1=1 kind formulas can be entered. but
=AND(H3=1,I3=0) cannot be entered. and when I try
="AND(H3=1,I3=0)" this way excel doesnt do anything,
and says i have an error

"Don Guillett" wrote:

formula =


Don Guillett
Microsoft MVP Excel
SalesAid Software

"mns" wrote in message
I want to check a column (lets say H) if there is a 1 value i want excel
color the row.

lets say there is a 1 on H6, I want to fill a color to row 6. It can be
coloring or if i can i might like to range it to A6:J6

thanx in advance