Hello,
could you please help me to solve the following problem:
Is it possible to use the formula =AND($G6>($D6+20000);$C21=$E21) and use different style of formatting for each condition (within AND function), which means the first conditions with red f.eg. and the second one with greater numer of font.
Thank you in advance for your help.
Regards,
Gosia
I send samlpe data for tests.
As i know,you can not use more than i style of formatting for each formula
Why don't you just use 2 different conditions?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
unless that is just an example that you dreamed up, you have 2 possibly conflicting, and completely unrelated conditions there?
you are referencing data on row 6 and then data on row 21? and comparing data in column D with G and then C with E - what is your expectation if D&G is true AND C&E is true?Is it possible to use the formula =AND($G6>($D6+20000);$C21=$E21
as Fotis pointed out, you cannot have 2 formats in 1 rule, you would need to separate rules for that
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks