Hi.
I'm trying to search in a column for the words "late" or "on time"
I want late to be in red, and on time to be green.
I've tried these, but they haven't worked worked:
=$G3="late"
=search("late", $G3)>0
workbook is attached
Hi.
I'm trying to search in a column for the words "late" or "on time"
I want late to be in red, and on time to be green.
I've tried these, but they haven't worked worked:
=$G3="late"
=search("late", $G3)>0
workbook is attached
Hello
If you're just trying to conditionally format each cell to either red or green font based on 'Late' and 'On Time', then you only need to select the range of cells and go to the Home tab Conditional Formatting > Highlight Cell Rules > Equal to... and enter your conditions and chosen format.
DBY
Oh thanks! I'm not too familiar with conditional formatting!
Glad to have helped. Thanks for rep.
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks