| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight cell
I have a grid 30 x 30. I have two fields that can be numbered 1-30
(associated with the grid. Looking for a way to highlight a cell based on entries in the fields. In other words, if the entries are 10 & 10, I want the corresponding grid position to highlight. The fields are straight entry, no special format |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight cell
On Jun 4, 3:29*pm, pff wrote:
I have a grid 30 x 30. *I have two fields that can be numbered 1-30 (associated with the grid. *Looking for a way to highlight a cell based on entries in the fields. *In other words, if the entries are 10 & 10, I want the corresponding grid position to highlight. *The fields are straight entry, no special format Sounds like you are looking for conditional formatting. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight cell
On Jun 4, 3:29*pm, pff wrote:
I have a grid 30 x 30. *I have two fields that can be numbered 1-30 (associated with the grid. *Looking for a way to highlight a cell based on entries in the fields. *In other words, if the entries are 10 & 10, I want the corresponding grid position to highlight. *The fields are straight entry, no special format For some reason im not sure if this posted.... It sounds like you want conditional formatting. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlight cell
What do you mean when you say "fields"? Cells on the worksheet? TextBox on
the worksheet (if yes, where did you get it from)? TextBox on a UserForm? Something else? Rick "pff" wrote in message ... I have a grid 30 x 30. I have two fields that can be numbered 1-30 (associated with the grid. Looking for a way to highlight a cell based on entries in the fields. In other words, if the entries are 10 & 10, I want the corresponding grid position to highlight. The fields are straight entry, no special format |
| 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 Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
| click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
| Highlight active cell and de-highlight previous cell | Excel Programming | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Linear Mode
