|
|
#1
Yesterday, 06:05 PM
|
|||
|
|||
Set parameters for conditional formatting
I'm not sure if this is possible but I keep being amazed at what spreadsheets can actually do so here goes
 I have a range of cells (J1 to J19) that are pre-determined height options and I was to set conditions to alert me (say, bright yellow background in A5) if the figure we type in to cell A5 is not one of the 19. Can it be done? Thanks Chris 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting | JHalter | Excel | 2 | 07-13-2023 03:49 AM |
 Conditional Formatting
|
solberg2004 | Excel | 2 | 01-27-2017 10:07 AM |
| Data validation using conditional parameters in Excel table | dougdrex | Excel | 2 | 01-06-2015 07:44 AM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Conditional Formatting | teza2k06 | Excel | 3 | 01-19-2014 02:34 AM |
Windows 7 32bit 
Office 2007
Threaded Mode