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


Thank you Russel, it worked.
But still need to have 3 conditions. Are they doable on one formula? if not
can I use priority thing on them? cause i need to make

I3 has a vaule of 1 mark the row Green
H3 has a vaule of 1 mark the row Yellow
I3 AND H3 has a vaule of 1 mark the row Green

colors are not imprtant. single ones are not problem. but I3 and H3
condition, is it doable?

"Russell Dawson" wrote:

Conditional formatting - new rule - use formula to determine which cells to
format -
Formula is =$H$6=1
Applies to =$A$6:$J$6

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"mns" wrote:

Hi,
I want to check a column (lets say H) if there is a 1 value i want excel to
color the row.

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

thanx in advance