EE.xlsx

<div>
Sometimes you can make a job a little too hard lol my only excuse for this is it is Friday lol<br />
<br />
guys thanks for pointing out the obviouse.<br />
<br />
Enjoy your weekends<br />
<br />
Darren
</div>


Sometimes you can make a job a little too hard lol my only excuse for this is it is Friday lol

guys thanks for pointing out the obviouse.

Enjoy your weekends

Darren

<div>
<div class="content wysiwyg-content">
Guys I know it is possible to use conditional format to alter cells but it is limited.<br />
I need to have a way to enter a value in a cell say A1 and a range of cells say G3:AK1000 to change colour and all matching to show up in red and everything else to go white.<br />
<br />
Can you help<br />
<br />
Regards<br />
<br />
Darren
</div>
</div>


Guys I know it is possible to use conditional format to alter cells but it is limited.
I need to have a way to enter a value in a cell say A1 and a range of cells say G3:AK1000 to change colour and all matching to show up in red and everything else to go white.

Can you help

Regards

Darren

Format cell colour based on value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.