Previous Topic Next Topic

IF Function

Closed
Alex - Mar 25, 2010 at 12:39 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 25, 2010 at 01:34 PM
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

Related:

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 25, 2010 at 01:34 PM
You do that in conditional formatting

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

Similar discussions

USB:\ is not accessible. Incorrect Function.
rickitikz -
Amar Yadav -

7 responses
Dell laptop FN key is not working
adibah -
Artur -

93 responses
Having Excel IF formulas print text and calc
martinwuff -
martinwuff -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses