Thread
:
YACFQ - Yet Another Conditional Formatting Question...
View Single Post
#
3
Posted to microsoft.public.excel.misc
Pete_UK
Posts: n/a
YACFQ - Yet Another Conditional Formatting Question...
Change the format condition to "Formua Is" rather than "Cell Value Is"
and enter this formula;
=AND(H150,H15<75)
You can still have the same red background format.
Hope this helps.
Pete
Reply With Quote