Forum Discussion
how do i set up an IF formula
colebaird89 Add one more Conditional Formatting rule to the ones you already have in the workbook.
=ISNUMBER(SEARCH("fire",D2)) and apply it to $G$2:$G$95 and set the format as you desire.
Demonstrated in the attached file.
You're on the right track, but you need to nest your IF statement inside a Conditional Formatting rule. But first, set your 'default' color to GREEN by selecting COL G>Font Color = GREEN.
Then, WITH YOUR CURSOR IN G1,
1. Launch the Conditional Formatting wizard
a. hotkeys = ALT+O,D, or
b. go to the Ribbon Home>Conditional Formatting>New Rule
2. Select Rule Type "Use a Formula to determine which cells to format"
3. In the "Format values where this formula is true:" formula bar, enter the following:
=IF(LEFT($D2,4)="Fire",TRUE,FALSE)
Then click "Format" and choose Color = Red
Click OK, OK,
In the "Applies to" field, enter =$G:$G
Click APPLY, OK
Copy cell G1,
Select COL G,
and lastly Paste Special > Paste > Click "Formats" > OK
(hotkey = ALT+E,S,T > Ok)
You're Done.
Hope this helps.
/C