Forum Discussion
Conditional formatting - multiple rows and columns
=$B9<=TODAY()=AND($B9>TODAY(),$B9<TODAY()+30)=$B9>=TODAY()+30I've adapted the rules for conditional formatting to column B which contains the due dates. In my first reply i didn't understand the actual layout of the data unfortunately.
=AND($K10<TODAY()+30,$K10>TODAY())Maybe like in the above rule for conditional formatting. I've changed $K$10 to $K10 in all 3 rules and it seems to work in the attached file.
The "applies to range" is adapted to the range of the data which is =$L$10:$W$28 in the attached example.
Thanks so much for the fast response! I think it was my bad for not being clear enough. If its not a terrible inconvinience for you i have edited my original post being more specific and with more details.
The problem is i want each row of "x" to read from each cell in the due date column and not only from k10 cell
Also i uploaded a sample with current formulas and format
=$B9<=TODAY()=AND($B9>TODAY(),$B9<TODAY()+30)=$B9>=TODAY()+30I've adapted the rules for conditional formatting to column B which contains the due dates. In my first reply i didn't understand the actual layout of the data unfortunately.
- Thank you so much for this! It's amazing how the lack of one $ changes it so much.
I ll run it through all cells and worksheets and let you know if anything weird occurs!
Take care
