i am tring to use the Conditional formatting for two thing:
1. if cells A1 & B1 & C1 have the value "no" then D1 will become red
2. if the cell A1 = "NO" COLOR IT TO RED AND GOTO CELL F1 ELSE GO TO CELL M1
ANY HELP
THANK YOU
YAIR
i am tring to use the Conditional formatting for two thing:
1. if cells A1 & B1 & C1 have the value "no" then D1 will become red
2. if the cell A1 = "NO" COLOR IT TO RED AND GOTO CELL F1 ELSE GO TO CELL M1
ANY HELP
THANK YOU
YAIR
1.select cell D1 goto-> CF,new rule,use formula =COUNTIF(A1:C1,"no")=3 format,fill choose a fill color ok,ok
2.select Cell A1 goto-> CF,new rule,use formula =A1="no" format,fill choose a fill color ok,ok
the goto a different cell part, I know of no way without using VBA/Macro's to accomplish this...sorry
Hope the rest helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Conditional formatting is as it says, you canuse it to change the format of the cell, but i am not aware of anyway to activate a cell using it.
You can do it with VBA though.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
thank you , regrding #1 it does not work for me , what does the =3 means
the =3 is a comparison, the formula reads as " count the cells in range of A1 to C1 that contain "no", if the count of cells containing "no" equals 3, then return TRUE, else return FALSE"
and it should work..working fine here..not sure..maybe a regional thing? if so try this
=COUNTIF(A1:C1;"no")=3
note the change from a comma "," to a semi-colon ";"
also, if you update your profile, then we would be able to see what version of excel you are using, and where you are from, which does make a difference
Hope that helps
yes thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks