IF Function

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
How do I get a cell to turn green if true and red if false? I want this to happen for multiple cells in the workbook. For Example:

IF cell A1 is true then change A1 from no shade to green.

IF cell B1 is false then change B1 from no shade to red.

So on for multiple cell.

Thanks for your help in advance

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You do that in conditional formatting

there you would write your condition and choose format to color the cell as u deem fit