dronka
Member
Help! I'm creating a template for a calendar, and I want to conditionally format the number cells so that if there's a holiday (e.g. text) in the cell below it, it will turn red. So, for example, I'd like the "1" for New Year's Day to be red because there's text in the cell below it.
See the attached file (Red Text sheet). I've tried an istext conditional format in cells A3:G3, trying to get it to reference the cell below in row 4, but to no avail.
Here's the file:
https://dl.dropbox.com/u/55797447/ConditionalFormatingProblem.xlsx
Thanks!
David
See the attached file (Red Text sheet). I've tried an istext conditional format in cells A3:G3, trying to get it to reference the cell below in row 4, but to no avail.
Here's the file:
https://dl.dropbox.com/u/55797447/ConditionalFormatingProblem.xlsx
Thanks!
David