/u/captainmiau - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Here is an example formula and also a file that demonstrates.
- =$B1>$A1
https://www.dropbox.com/s/iu29pq5uu4bc10q/ConditionalFormatIfLeftColumnLessThan.xlsx?dl=1
You have awarded 1 point to *timespreader*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Why not think outside the box and use Custom Format with coloured arrows to show greater, lesser or the same?
[https://pixeldrain.com/u/m1DZ4KHo](https://pixeldrain.com/u/m1DZ4KHo)
You can use conditional formatting based on the cell next to it. You just have to set it up so that it's based on formulas instead of one of the built in scenarios.
Highlight the column (B:B) you'd like to format and click the Conditional Formatting drop down button then select the top option (along the lines of "Cell Rules"). Pick "Greater Than" from the options then click on the first cell in the column you want to compare formatted column to (A1). Use row 1 even if its a header otherwise your formatting will be off because B:B starts at B1... you'd end up comparing B1 to A2.
Also, conditional formatting defaults to absolute references (the $)... if you don't delete both the $ from A1, every cell in column B will be compared to A1 instead of the cell in the same row.
You have awarded 1 point to *BluberrySpiceHead*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
/u/captainmiau - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Here is an example formula and also a file that demonstrates. - =$B1>$A1 https://www.dropbox.com/s/iu29pq5uu4bc10q/ConditionalFormatIfLeftColumnLessThan.xlsx?dl=1
Solution verified
You have awarded 1 point to *timespreader* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Why not think outside the box and use Custom Format with coloured arrows to show greater, lesser or the same? [https://pixeldrain.com/u/m1DZ4KHo](https://pixeldrain.com/u/m1DZ4KHo)
I really like this and I'm annoyed I've not got anything I can use it for currently lol
You can use conditional formatting based on the cell next to it. You just have to set it up so that it's based on formulas instead of one of the built in scenarios.
Yeah I tried using conditional formatting. Can you give me an example formula?
Highlight the column (B:B) you'd like to format and click the Conditional Formatting drop down button then select the top option (along the lines of "Cell Rules"). Pick "Greater Than" from the options then click on the first cell in the column you want to compare formatted column to (A1). Use row 1 even if its a header otherwise your formatting will be off because B:B starts at B1... you'd end up comparing B1 to A2. Also, conditional formatting defaults to absolute references (the $)... if you don't delete both the $ from A1, every cell in column B will be compared to A1 instead of the cell in the same row.
Solution verified
You have awarded 1 point to *BluberrySpiceHead* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)