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
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
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:
- IF Function
- Accessor function c++ - Guide
- Find function on mac - Guide
- Spreadsheet function - Guide
- Network card function - Guide
- Hard drive function - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 25, 2010 at 01:34 PM
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
there you would write your condition and choose format to color the cell as u deem fit