I want a format, conditional format or formula to change the colour in a calendar range depending on whether a '1' appears on column 'R' on my spreadsheet. The range already has a conditional format that returns a colour if dates match but I want to change the colour if the dates match but also if a '1' appears in column. The attachment explains things better than maybe I can put into words.
Any help would be much appreciated this is a request from my boss!
Mr c.
Your attachment is missing, but the general formula for Conditional Format would be something like:
=AND(A1=B1,R1=1)
Where A1 and B1 are the cells with dates to compare and R1 is cell with value of 1. Both conditions must be true for the conditional format to apply.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Hi, Mnay thanks for your reply, I have now attachment now included....!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Mclocherty 
Register To Reply
Bookmarks