Conditional format if cell contains formula
sure.
here's an example
A B C D E F G
1 no1 no2 no3 no4 no5 no6
2 ticket1 2 15 26 27 36 38
3 ticket2 1 12 13 15 24 34
4 ticket3 3 5 20 28 37 40
5
6 drawn 3 15 25 26 47 49
1. Select cells B2:G4
2. Select Conditional Formatting
3. Choose Formula Is (as opposed to Cell value is)
4. For the formula, use the CountIf function:
=COUNTIF($B$6:$G$6,B2)
5. Click the Format button.
6. Select formatting options (choose a color for the cell), click OK
What happens is that the conditional formatting formula will evaluate each
cell to see if it should "count" according to the criteria. Once it is
"counted", it will apply the format to the cell.
Try it, its fun.
Yong Heng
"Jean-Marc" wrote:
Is there a way (conditional formatting?) to apply a different format to cells
that contain a formula, as opposed to cells that have a directly entered
value?
|