Oct 04 2021 07:33 AM - edited Oct 04 2021 07:33 AM
I was trying to do conditional formatting for A2 to K2, based on H2 & K2, but it is not working.
The idea is whenever I am giving the actual dates in the respective cells, it should give conditional formatting like, when I enter actual start dates, it should give "yellow" color, when I enter actual finish dates, it should give "green" color.
Please help.
Oct 04 2021 07:45 AM
Oct 06 2021 04:43 AM
@Hans Vogelaar : Thanks, This is working in this file, but when I tried to do same with another file but it is not working, is there any condition for this for not working, if I am still having those empty cells to give input. but some reference of it is given for calculation in some other cells ?
Oct 06 2021 04:49 AM
Please check data range to which rule is applied, first cell in it which used in formula and using of absolute/relative references. Usually issues are about that.