Hi Guys,
is there any way to give colours in cells based on values without using conditional formating
Ex: if a1 = 50 then it should be Red like this
Hi Guys,
is there any way to give colours in cells based on values without using conditional formating
Ex: if a1 = 50 then it should be Red like this
yes with VBA/macro
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
with out macro....is there any way.....
short answer...no. Why do you not want to use conditional formatting?
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
Actualy this question asked me in an interview..i said no and with macros we can do it....
Then you gave the correct answer to them, well done
thank you........
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks