Forum Discussion
Color to a line with conditions
Hi!
I'm trying to implement a spreadsheet to register extra information locally about some maintenace requests and general status. I apologize if I'm asking something absurd, I just have no idea if it's possible.
What would help me is if the whole line gets colored in red if the time between the "Opening date" (E column) and today (B3) is above 15 days, but at the same time if there is any information on "Closing Date" (F column) the whole line gets painted green.
If it's possible how can I do that?
5 Replies
What you're working on looks admirable (from an objective perspective) but if you're doing supplementary data entry to do the monitoring (rather than "suck" data in) it is likely you're going to create work for yourself. It would seem to me that using Power Query has the potential to save you a lot of time. Would be interesting to know more about where the base data is entered in the first place.
Vinifernandes Use conditional formatting as demonstrated in the picture below:
(Picture taken on a Mac, but similar for PC)
Select the entire range you want to format and add the formulae as indicated. The "Applies to" field will automatically be filled with the reference to the selected range. Added these to your file as an example.
What you're working on looks admirable (from an objective perspective) but if you're doing supplementary data entry to do the monitoring (rather than "suck" data in) it is likely you're going to create work for yourself. It would seem to me that using Power Query has the potential to save you a lot of time. Would be interesting to know more about where the base data is entered in the first place.
RobertHind Why ask me? I just responded to the question how to apply conditional formatting.
