# Formatting cells based on the value of other cells.

#### Robynasu

##### New Member
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?

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### Lenny81

##### New Member
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

##### Well-known Member
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

##### New Member
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

##### New Member
Thanks! I think I got it to work.

Replies
1
Views
222
Replies
3
Views
583
Replies
2
Views
211
Replies
2
Views
316
Replies
7
Views
158

1,195,924
Messages
6,012,324
Members
441,690
Latest member
CyberWrek

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back