View Single Post
  #1   Report Post  
steve-o
 
Posts: n/a
Default Conditional Formating for a cell based on another cell's value

Hi all:

I was wondering if there was a way to put a conditional formating on a cell
based on the values of another cell. What I mean is that, if Cell A is 5 ,
make cell b Blue, not just cell A. Likewise, if Cell A is <5, make both cell
a and b red.

On the same topic, is it possible to put more than 3 conditions on a
conditional formating?

Thanks,

Steve o