Forum Discussion
Solved
Conditional formatting - multiple rows and columns
Good day everyone! I am working on a barebones PMS for our vehicles and i am stuck with the conditional formatting of cells. As you will see below in the attached image i need to format "x" w...
=$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.
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