Hi,
I need help with the sheet attached, I want C1 cell change colour according to value in a1 and c1 itself.
If a1 =0 then c1 red
if a1 =1 then c1 no colour
if c1 = blank no colour
if c1 = text value light grey
Please help me if their is way to do this,
Thanks in advance for your time and help.
RRBook1.xls
Last edited by robrobet; 10-23-2014 at 11:43 PM.
Hello robrobet,
You do realize that A1 will override whatever is in C1. Is this how it should work?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
cf example.xls
Is this what you want? Clearly when two conditions exist you'll need to decide which CF overides. Use the order button and the tick to stop so that it gives you your desired outcome
Happy with my advice? Click on the * reputation button below
How I can do this, is there another way to do, what I want to
C1 stay white if nothing
If c1 have text value then change it to grey
and I want third option to change the colour
Any suggestions
Change the order. Put the two "white' formats as 1 and 2 then the red and grey format as 3 and 4 and tick the boxes to tell it to stop when it triggers that CF
Sorry I did not got it, C1 is not staying white, can you do it on the sheet for me. May be I did not explain my self very well.let me explain this way
a1 blank c1 blank then c1 stay white
a1 blank c1 have text value then change it to grey
if I input in a1 (0 or 1 ) that override and change to red.
thanks for your time.
cf example.xls
I think this matches your request
A 0 in A1 though is differnt to a blank
Thank you very much for your time and help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks