Forum Discussion
if Function
Using the Excel IF Function. I need help having the IF Function turn text values red of black depending on the true or false value of the IF Formula...
3 Replies
You may apply Conditional Formatting https://support.office.com/en-us/article/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
- I need to know how to have the "text" show the black color if the 2nd condition is true, and red if the 3rd condition is false. Cell a1 equals 2. If(a1 greater than 1), which is true, text is red. If (a1 is not greater than 1, which is false, text is black.
You may select your range, open Conditional Formatting, add new rule with formula, add formula as here
select desired format and apply.
Similar for any other color (format) - one rule per color.
