View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] DKlecka@gmail.com is offline
external usenet poster
 
Posts: 1
Default Conditional Formating Question

Okay, here's what I want to do - but can't find out how to do it.

Say I have data in cells A1:A5, B1:B:5, C1:C5, D1:D5, E1:E5.

I want to apply a conditional format to the values in cells A1:A5.
Say, if the number is less then 5, then make it green. I would
ideally like to apply the same format to the entire row. So, if cell
value in A3 was 2, then B3, C3, D3 & E3 would also be green.

Is there an easy way to accomplish this?