Forum Discussion
Spreadsheet help with formulas to change background color
I am struggling to add a background color to my sheet. I have below requirement. Sheet1 has the following data: Date and Time Data1 Data2 Data3 Data4 6/1/2017 7:00 0 10.5 2 3 6/1/2...
Hi Shilpa,
On the picture and in the attached file step by step formula modification for your first example. Latest formulas assume you define between which cycles to color in column G of the Sheet1, by INDEX/MATCH you find time for defined cycles in Sheet2 and compare them in conditional formatting formula with times in column A of Sheet1. If the time is within the range
=($Ai >= cycle1 time)*($Ai >= cycle2 time)
formatting is applied.
Sergei,
Thank you so much of detail steps. I tried and it is working fine.
Thank you!
Shilpa