View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nic Daniels Nic Daniels is offline
external usenet poster
 
Posts: 23
Default Conditional formatting based on numbers in columns


Hi,

I would like to change the background color of a two cells (row by row)
based on values in two other cells in the same row.


If C10 AND if C1D1, the background color of cell A1 turns green and B1
turns red.

but If C10 AND C1=D1, the background colors of both cells, A1 and B1 turn
green.


Ex:
A B C D
1 Green Red 1 0
2 Green Green 12 12
3 No change in background color

Thank you!


--
Kind regards, Nic