Reputation: 1
Need to fill a colour into the cells individually, if condition gets OK. Each cell with reference of different cell.
Means if value of C1 is not between A1 & B1, C1 fills with red,
likewise, if value of C2 is not between A2 & B2, C2 fills with red if value of C3 is not between A3 & B3, C3 fills with red..
Upvotes: 0
Views: 227
Reputation: 27521
In Excel, the Conditional Formatting can do this
Select the range of cells, and click Home > Conditional Formatting > New Rule.
Then in the New Formatting Rule dialog, select Use a formula to determine which cells to format in the Select a Rule Type list, and type this formula =OR(C1<A1,C1>B1)
into the Format values where this formula is true textbox, and click Format button to enable the Format Cells dialog, under Fill tab, and select one color you want to use for highlighting. See screen-print
Click OK > OK. Then the cells which are not in the number range have been highlighted
Upvotes: 3