Quote:
Originally Posted by ConneXionLost
Not sure why the first one didn't function as expected (posting issue?).
Here's a second attempt.
In case there's a problem here as well, then you may need to build it manually.
1. Select the entire second row of your sheet.
2. Got to "Conditional Formatting", and set "Formula is:
3. Select the red background colour, and click Okay.
Cheers, |
Thanks. It is quite nice in your worksheet. But where can I write the formula in "Conditional Formatting" because there are several options. Which one is appropriate to write the above code? Please do further help.