I don't usually have a problem with this for my simple needs, but this has got me beat.
The value in C48 is a date, 44526 in this case.
I want to apply conditional formatting to the entire range a47:q56 if the displayed value is less than 8
In my head, text and value convert the 44526 in this case to a 1, but I can't get the conditional formatting to change the formatting.
The value in C48 is a date, 44526 in this case.
I want to apply conditional formatting to the entire range a47:q56 if the displayed value is less than 8
In my head, text and value convert the 44526 in this case to a 1, but I can't get the conditional formatting to change the formatting.