Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2020, 11:06 PM
Purfleet Purfleet is offline How to compare two cells in a worksheet and show the result as red or green in a cell another work? Windows 10 How to compare two cells in a worksheet and show the result as red or green in a cell another work? Office 2019
Expert
How to compare two cells in a worksheet and show the result as red or green in a cell another work?
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

It much eaiser if you add example workbooks so that we dont have to spend time recreating the senario.



This conditional formatiing should work - i find it easier to do the rule then paste it into the conditional formatting formula box
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compare two cells in a worksheet and show the result as red or green in a cell in another wor Oldman45 Excel 11 07-05-2020 12:59 AM
Copy colored cells to new worksheet (maintain cell position) naeemakhtar Excel Programming 2 06-06-2020 04:02 PM
Data Compare and result as true or false in result sheet aligahk06 Excel 1 08-29-2019 06:44 AM
How to compare two cells in a worksheet and show the result as red or green in a cell another work? Show result of formula as a value in another cell Steve_D Excel 4 10-12-2014 07:38 PM
Can I create a formula that will show result in the same cell and let me copy it down CranstC Excel 1 02-11-2012 01:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft