ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   If Statements (https://www.excelbanter.com/excel-discussion-misc-queries/78945-if-statements.html)

Dbettini

If Statements
 
In an 'If Statement' is it at all possible to have the cell change font
colour or cell colour if the statent is false.

Duke Carey

If Statements
 
Use FormatConditional Formatting.

Select the cell that contains your formula and go to FormatConditional
Formatting. Use "Cell value is" and select "Equal to" and then type in
false. Click on the format button and choose the Pattern you want or change
the Font color

"Dbettini" wrote:

In an 'If Statement' is it at all possible to have the cell change font
colour or cell colour if the statent is false.



All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com