LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pheasant Plucker®
 
Posts: n/a
Default YACFQ - Yet Another Conditional Formatting Question...

I'll never get the hang of this...:-(

I had a similar problem recently that was solved in this ng (Thanks Dave:-)
but have a related problem that I thought I could solve by applying the same
logic - alas it was not meant to be for me :-(

I want to use Conditional Formatting to achieve the following - if the value
in Cell H15 is lower than 75 then colour it red.

This I can achieve quite easily by using the following in Condition 1:

If Cell Value is Less Than 75 then Format Pattern Red

However I do not want the cell to be coloured Red if there is no value in
there at all - I only want to be able to turn the cell red after I have
input the value and that value is less than 75

Obviously I need to test for input in H15 prior to checking if it is below
75 and invoking the colour change if it is - leaving no change if it has no
value or is 75 or above.

I have tried using a COUNTA but cannot seem to get it to work.

Can some kind soul help me out on this one (again) please?

--
Thanks & regards,
-pp-


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting - Formulas meandmyhorse Excel Discussion (Misc queries) 2 February 18th 06 12:58 PM
Conditional Formatting GoldDave Excel Discussion (Misc queries) 6 October 6th 05 02:53 PM
Conditional formatting...cont. from 9/25 Guenzak Excel Discussion (Misc queries) 4 September 26th 05 10:55 PM
Conditional Formatting Cell < Today() sagan Excel Worksheet Functions 3 September 21st 05 03:43 PM
Conditional Formatting in Excel Help Please..... Willie T Excel Discussion (Misc queries) 4 February 9th 05 02:28 PM


All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"