View Single Post
 
Old 11-12-2025, 06:05 PM
Windspeed Windspeed is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jun 2017
Posts: 9
Windspeed is on a distinguished road
Default 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
Reply With Quote