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" where it exists with either red, yellow or green depending on the month that service needs to be done. Total there are 600 rows that this needs to apply.
Edit,1: Updated the attached image so you can have a better understanding - i also uploaded a sample of the table with the current formulas and formatting.
Edit,2: "x" appears on each corresponding month using this formula: =IF(AND(MONTH(K10)=1;YEAR(K10)=YEAR(Z1)); "×"; "") and depends on DUE DATE Column's date for each row to read from.
i have managed to make it work for a single row but when i try to apply it to all rows its just ignores the formatting and displays only red no matter the source date - even i change the formula manually.
I am stuck on this for some time and i can not bear the thought of making each row independently for 600 rows - it will take me forever.
I would appreciate your help!
Thanks in advance and best regards to all!
Gigawattz
=$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.
