conditional formatting 2 criteria in one row
Select cell (let's say B2)
Format- Conditional Format
Choose "Formula is"
Input the following:
=AND(B2A2,B2=C2)
Select format, click 'ok'.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"gimpy" wrote:
I would like to apply a conditional format in a row, where the first
condition is that the value be greater than the cell on the left AND equal to
the one on the right.
How do I get both conditions met using conditional formatting?
|