Hello:
Please refer to attached excel file/Sheet3
I want to use conditional formating to highlight the cell based on 2 criterio.
Column B has values in it.
I want to highight only the cell in a row which is not blank and the corresponding value in column B is less then 20.
In the attached sheet i have highlighted manually for the above requirement.
Please help with this.
Thanks
Riz
Last edited by rizmomin; 05-03-2013 at 11:18 AM.
Hello,
Please see if the attached file is what you are looking for.
(copy pasta from Ford)
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
Regards,
Lem
Hi Lemice:
Hello:
I think there is some misunderstanding.
Please open my original worksheet and go to Sheet3.
Here you will see data in Column B.
My condition:
If the value of cell in column B is greater then -20 (in the sheet i have -27 and -22) positive then need to highlight the cell in that row.
If the value of cell in column B is less then -20 then no need to highlight the cell in that row.
Please see that i have hence highlighted the cell with value in column B is -27 and -22.
Please let me know if any questions.
Thanks
Riz
I read your first post and I thought you only want to highlight cell less than 20.
And, what do you mean by greater than -20 positive?
Does the attached help?
Hello Pepe and Lemice:
Both of your solution worked.
I am sorry for delayed response.
Thank u so much .
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks