mitchbagby
New Member
- Joined
- May 28, 2015
- Messages
- 2
I'm trying to get certain rows to change the background color if a certain cell contains a Month. I want this to work for the entire spreadsheet.
For example:
I have columns from A to I and rows from 2 to 10. The dates are in column I ranging from January to June. If a row is January I want the background of that row to be red. If it's February the background to be green and so forth.
I have tried several SEARCH formulas but I can't get it to work. Please help.
Thanks.
For example:
I have columns from A to I and rows from 2 to 10. The dates are in column I ranging from January to June. If a row is January I want the background of that row to be red. If it's February the background to be green and so forth.
I have tried several SEARCH formulas but I can't get it to work. Please help.
Thanks.