Conditional Formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting

FAQ

Thread Tools

Display Modes

04-29-2021, 01:53 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 Conditional Formatting

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Hi

Select cell A16 > Home Tab > Conditional Formatting > New Rule > Select - Use a formula to determine which cell to format. In the "Format values where this formula is true:" type the following "=$A$16="Y", click format button and apply your format preference.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting	Paul_	Excel	4	05-10-2019 05:08 AM
Conditional formatting	dayperson	Excel	1	02-23-2016 09:07 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional formatting	zanat0s	Excel	4	01-20-2012 03:30 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 AM.