LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Problem with conditional formatting

CF *stops* at the *first* TRUE condition.

SO, make condition 1:

=AND($A7<"",$C7="Cash Withdrawal")
And format to orange with borders.

Condition 2:

=$A7<""
And format to just borders.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"WLMPilot" wrote in message
...
I am setting up a basic check register for someone. I have turned off the
gridlines.
I have set up two conditions that I want something to happen and I cannot
get one of the conditions to kick in.

Entry for transactions begin on row 7. For this question,
Column A = DATE (beginning in A7) and
Column C = Description (beginning in C7)

Condition 1: Formula Is -- =AND($A7<"")
FORMAT is a thin line border. Since gridlines are off, this is to
create a border
for all columns for the current row (transaction) being entered.

Condition 2: Formula Is -- =AND($C7="Cash Withdrawal")
FORMAT is font of bold orange. This condition is painted across

columns
Date, Check Number and Description (Column C).

CONDITION 2 is not working. Any ideas?

Thanks,
Les


 
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 Problem myssieh Excel Discussion (Misc queries) 3 February 15th 08 04:10 PM
conditional formatting problem T. Valko Excel Worksheet Functions 10 June 22nd 07 02:39 AM
Conditional Formatting problem James A Excel Discussion (Misc queries) 3 January 1st 07 07:50 PM
Conditional Formatting problem Neo1 Excel Worksheet Functions 3 March 7th 06 12:18 PM
Conditional Formatting problem Cumbo Excel Discussion (Misc queries) 2 January 5th 05 03:44 PM


All times are GMT +1. The time now is 03:10 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"