Forum Discussion
Solved
Creating conditional formatting in cells OTHER than the selected cell
I'm a diabetic and am working on a spreadsheet to keep track of insulin needs. The data (both collection, ie: unlocked cells) and calculation (ie: locked cells) is spread across columns A:P, organize...
bwy1129 Not sure if I understood but I believe you can use the following formula to set the CF-rule:
=$B1=TODAY()
and apply it to the entire data range, e.g. $A$1:$P$4015
This should highlight the entire row, for each row where the date in column B equals today's date.
A working example is attached.
bwy1129 Not sure if I understood but I believe you can use the following formula to set the CF-rule:
=$B1=TODAY()
and apply it to the entire data range, e.g. $A$1:$P$4015
This should highlight the entire row, for each row where the date in column B equals today's date.
A working example is attached.