Forum Discussion
Color to a line with conditions
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.
My apologies ... I thought I was replying to the original post. Sorry
