• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Help..

F

FlasHBurN

Golden Member
I am trying to make a formula that changes the color of a cell, depending on how it compares to another...

For example I have a cell (A2), I want to compare its value to another cell (B2). If B2 is greater than A2, I want to change the color of A2's cell.

I already know how to change the color of a cell based on its comparison to a specific number, but I cannot figure out how to change it based on the value of another cell.
 
Conditional formatting is your friend

you'll need to use an if statement

pm me if you need specifics
 
ok, specifics...

in cell A2, go to format-conditional formatting

first box should say "cell value is", 2nd box should say "is greater than", third box should say "=$b$2

click on the format box, choose the 'patterns' tab, and select your color - you should be all set

you may also want to put in some data validation conditions to make sure the values in column A are only numbers too
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top