| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to highlight cells ?
I have a spreadsheet that consists of 100 columns with 100 rows;
How can I highlight a cell whose value exceeds 500? tia |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to highlight cells ?
From menu select Format|Conditional formatting
Set Condition Cells value is greater than 500. Select the format you would need. Click OK If this post helps click Yes -------------- Jacob Skaria "Sul@MS" wrote: I have a spreadsheet that consists of 100 columns with 100 rows; How can I highlight a cell whose value exceeds 500? tia |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to highlight cells ?
Please review this article http://www.contextures.com/xlcondFormat01.html
If this post helps click Yes -------------- Jacob Skaria "Sul@MS" wrote: I have a spreadsheet that consists of 100 columns with 100 rows; How can I highlight a cell whose value exceeds 500? tia |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to highlight cells ?
thanks
works in Excel XP "Jacob Skaria" wrote in message ... From menu select Format|Conditional formatting Set Condition Cells value is greater than 500. Select the format you would need. Click OK If this post helps click Yes -------------- Jacob Skaria "Sul@MS" wrote: I have a spreadsheet that consists of 100 columns with 100 rows; How can I highlight a cell whose value exceeds 500? tia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| Highlight cells in a row with a given value | Excel Discussion (Misc queries) | |||
| Trying to highlight cells | Excel Discussion (Misc queries) | |||
| Highlight Cells | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Linear Mode
