![]() |
#8
|
||||
|
||||
![]()
Perhaps this is a bit simpler
Code:
=isnumber(h4)*OR(H4<$E4,H4>$G4)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Gary Drumm | Excel | 3 | 02-22-2014 01:43 AM |
![]() |
secoo140 | Excel | 1 | 10-12-2013 07:19 PM |
Table with Conditional Format to Word | billyV | Excel | 9 | 06-07-2013 08:26 AM |
Copy format created by a conditional formatting | spk | Excel | 2 | 04-10-2013 04:41 AM |
![]() |
pmregan | Word | 1 | 09-19-2012 07:09 PM |