Conditional Formatting

miriaml

New Member
Joined
Apr 18, 2019
Messages
1
Please Help!!!:confused::ROFLMAO:

I have a testdata sheet whih there is a min and max spec.
i can setup the conditional formatting for less than, geater than, but here is where i am stuck....

Sometimes there is no spec but because i have a format for less/greater than it autoamatically highlights the cells.

if i dont have a spec i need the cells to be colour free

any help on this would be greatly appreciated :)
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,768
Office Version
365
Platform
Windows
Hi & welcome to MrExcel.
What is the formula you currently use?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,752
Messages
5,446,301
Members
405,396
Latest member
SpiFF2000

This Week's Hot Topics

Top