Forum Discussion
Solved
how do i set up an IF formula
i am trying to set up a formula for my daily occurrence book. the formula that i need is if in column's D the text is specified by Fire Alarm Activation that the text colour in columns G are in red ...
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.
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.
This worked exactly how I wanted thank you so much I’ve been working on this for over a week and you sorted it for me thank you x