How to Highlight greter than value from selected cell

[vinayvanam]

How to Highlight greter than value from selected cell

Ex: for Example cell 1 value is 10, remaining 2,3,4,5 cells i need to highliht gretaer than 10 values.

Please help

10	5	4	11	12
20	15	16	19	21
30	21	25	31	33

<TBODY>
</TBODY>

 

[Andrew Poulsom]

Your question is unclear. What do you mean by "remaining 2,3,4,5 cells"?

 

[vinayvanam]

i want to highlight, greter than cell 1 values.

 

[Andrew Poulsom]

Can't you use Conditional Formatting?

 

[vinayvanam]

yes

 

[vinayvanam]

i can use but i dont know the formula to highlight.

 

[Andrew Poulsom]

You can use a condition like:

Cell Value greater than =$A$1