Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-11-2018, 04:08 AM
ArviLaanemets ArviLaanemets is offline Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Windows 8 Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Office 2016
Expert
  
Join Date: May 2017
Posts: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Conditional Formatting is for changing the outlook of cells or their contents.

You have Shapes (i.e. certain Objects) placed over cells - from 0 up to 2 different Objects per cell area (NB! Not in cell!).

An example how to do something using Conditional Formatting is in attached workbook.
Attached Files
File Type: xlsx Form 1.xlsx (31.5 KB, 18 views)
Reply With Quote
  #2  
Old 10-11-2018, 01:34 PM
Marcia's Avatar
Marcia Marcia is offline Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Windows 7 32bit Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Office 2007
Expert
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon 		 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by ArviLaanemets View Post
Conditional Formatting is for changing the outlook of cells or their contents.

You have Shapes (i.e. certain Objects) placed over cells - from 0 up to 2 different Objects per cell area (NB! Not in cell!).

An example how to do something using Conditional Formatting is in attached workbook.
Thank you, is there no way to shade half of the cell area in conditional formatting?
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
New learner need help - convert tables in word format to ppt slides. sas Word VBA 5 09-21-2017 08:33 PM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Good morning/afternoon/evening based on time dwirony Word VBA 1 01-03-2017 01:01 PM
Need conditional formatting formula namedujour Excel 1 05-27-2016 08:58 AM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Conditional Formatting Formula teza2k06 Excel 1 08-22-2014 02:49 AM
Conditional Formula UICOMP Excel 1 05-18-2012 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:02 AM.

Contact Us - Privacy Statement - Top

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