|I refer to an old post (posted at September 24, 2009 at 02:21:42) regarding the captioned.|
I have an excel file where I originally have different colors for different columns to represent different data. However, if a specific cell fulfills a condition, say "Cancelled" (I already have a drop down, providing options like "Normal" and "Cancelled", for this), I would like the whole row to be changed to gray.
I followed the instructions given in that old post:
1) Select the whole of a row
2) Choose "Conditional Formatting", "Manage Rules", "New Rules", "Use a Formula to Determine......"
3) Enter the formula "=IF($K$10="Cancelled",TRUE,FALSE)
4) Set the format (gray fill)
5) Click "OK"
However, only the first cell of the row had its color changed to gray. I wonder if I did anything wrong. Or is it not possible for the conditional formatting to work because I have different colours for the same row?
Thanks for your help in advance.