Previous Topic Next Topic

IF Function

Closed
Alex - Mar 25, 2010 at 12:39 PM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

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

2 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response