for example if cell C2 is equal to cell F2 then C2 font colour should change to green, if it not equal then C2 should change font colour to red
I realise this is simple, but I am a beginner with these functions.
I am using Excel for Mac 2011.
much appreciated.
NL
Fellow Forum Members,
I have a lot of cells containing numbers and with dark colored highlights applied that makes the numbers hard to read. I also have other cells with colors like Yellow that is easy to read the black colored fonts.
What conditional formula can I use to change Black Font...
My boss has seen a word cloud and now wants me to create one (in Excel 2003).
Problem, I can't use Wordle for security reasons. Partial solution - I have used the (mighty!) Chandoo's solution to create a cell populated with words with font size based on frequency of use. However Chandoo's...
Is it possible to change the font for a validation list, specifically to change the colour of characters 11 and upwards for the names that appear in the drop down list?
I've tried changing the source list cells but it doesn't change what appears in the drop down list.
Any help would be most...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.