| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditionally format cell in a range, based on value in other rang
okay, i didn't think this was that hard, but i seem to be stuck.
i have a range of values, say AH2 thru AH63, and i want to compare these cell values with the same cell values in range AF2 thru AF63. if they are not equal, i would like them highlighted. so, if AH2< to AF2, then highlight it. can i do this with a range or do i have to have a format on each and every cell!?!? thanks in advance!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally format cells based on part of their text? | Excel Discussion (Misc queries) | |||
| how can I conditionally format a cell based on the value in a diff | Excel Discussion (Misc queries) | |||
| I'd like to conditionally format a cell based on today's date | Excel Discussion (Misc queries) | |||
| Can I conditionally format a line based on a cell value | Excel Discussion (Misc queries) | |||
| Conditionally format points based on a third column | Charts and Charting in Excel | |||
Threaded Mode
