Formatting cells based on the value of other cells.

[Robynasu]

I have formatted a cell to turn a color if it is great than or equal to .01 (E13). I would like to be able to say if E13 is greater than or equal to .01 than B22 needs an explanation before you can go on. Is that possible? If not, can I make B22 turn a color based on information above?

 

[Lenny81]

I have formatted a cell to turn a color if it is great than or equal to .01 (E13). I would like to be able to say if E13 is greater than or equal to .01 than B22 needs an explanation before you can go on. Is that possible? If not, can I make B22 turn a color based on information above?

Hi,
I do something similar. If you use Conitional Formatting in B22 using the following:
=AND(E13>=0.01,B22="") and set your colour to e.g. Red, then B22 will turn red if E13 is greater than or equal to 0.01 but the red will disappear once text is entered.

 

[DRSteele]

Oh, yes --- you can make the format of B22 depend on another cell. While in cell B22, click Conditional Formatting|New Rule|Use Formula...|Format Values where...|type =E13>=0.1|and then set the format using the buttons|click OK.

I suggest you watch this video and it will explain all you ever needed to know about Conditional Formatting (https://www.youtube.com/watch?v=GRfe4bHsjhI).

 

[Lenny81]

I think if you want the colour formatting to disappear once an explanation is entered in B22 you will need to add the B22="" (basically making it stay red while it's empty once E13 meets the >=0.01 criteria

 

[Robynasu]

Thanks! I think I got it to work.